Cost Data Export

The Cost Data Export feature allows you to export Cobra data for integration with Acumen or wInsight using the Cost Data Wizard. This feature also supports other formats and proprietary export formats.

You can use the Cost Data Wizard to:
  • Generate the Deltek Common Data (DCDE) format, which is a standard format for cost data that can be read by Acumen or wInsight.
  • Generate the Integrated Program Management Data Analysis Report (IPMDAR) format, which is a format for cost data that is required by the US Department of Defense for reporting project performance. This IPMDAR file is exported in ZIP format.
  • Generate the Department of Energy Project Assessment and Reporting (DOE PARS) format, which is a format for cost data that is required by the US Department of Energy for reporting project performance. The DOE PARS file is exported in ZIP format.

The Cost Data Export supports creating and saving configurations that can be used for future exports as well as by the API to automate the export process. You can back up and restore a saved configuration, similar to the Integration and wInsight configurations.

To secure access to the Cost Data Wizard, click Integration > Cost Data in the EPM Security Administrator tool.

For DCDE, IPMDAR, and DOE PARS Formats

Here are some important things you need to know when creating the DCDE, IPMDAR, or DOE PARS format:
  • To export Reprogramming Adjustment values, you must create the ReprogCVA and ReprogSVA cost sets.

    When you are creating a new project and the Copy defaults from project option on the General Information page of the New Project Wizard is cleared, the ReprogCVA and ReprogSVA cost sets are created in the new project. To view the project's included cost sets and to add classes to each cost set, use the Cost Sets tab of the Project Properties dialog box.

    During Cost Data Export, the Reprogramming Adjustment values are exported to:

    • The Reprogramming Adjustments and Summary Performance files of the generated JavaScript Object Notation (JSON) files for the IPMDAR format
    • The DCDE file for the DCDE format
    • The Cost file of the generated JSON files for the DOE format
  • You must assign the results to the resource in the resource file with the correct result code in order to group the data as hours, direct costs, and burdens. All data results required for export must have one of the following result codes:
    • D: Direct
    • C: COM
    • O: Overhead
    • G: G&A
Note: If the result code is left blank, Cobra will assume the resource is Indirect.

For IPMDAR Format

Here are some important things you need to know when creating the IPMDAR format:
  • By default, Cobra concatenates the Control Account (CA) key fields and the Work Package (WP) ID during the Cost Data Export process. If you want to disable concatenation, select the Do not prefix Work Package ID with Control Account ID option in the Cost Data pane of the Integration tab of the Application Preferences dialog box.

For DCDE Format

Here are some important things you need to know when creating the DCDE format:
  • You must ensure that the number of flagged periods in Calendar Set 19 is complete and correct.